Hệ thống quản lý trường học bằng PHP / MySQLi
1 <!--this are php codes to fetch data from the database. the data is later displayed in the fields provided-->
2 <?php
3 error_reporting(0);
4
5 ?>
6 <?php
7 SESSION_START();
8 ?>
9 <?php
10 //error_reporting(0);
11
12 $conn=mysqli_connect('localhost','root','','sms2')or die(mysqli_error("Connection error"));
13 ?>
14
15 <?php
16 require_once('session1.php');
17
18 ?>
19 <?php
20 $id = 1;
21 $select = "SELECT * FROM
22 companyinfo WHERE auto=1";
23
24 $result = mysqli_fetch_array(mysqli_query($conn,$select));
25 $qry=mysqli_query($conn,$select);
26 if($qry)
27 {
28 while($rec = mysqli_fetch_array($qry)){
29 $cname = "$rec[cname]";
30 $cemail = "$rec[cemail]";
31 $ccontact = "$rec[ccontact]";
32 $clocation = "$rec[clocation]";
33 $clogo = "$rec[clogo]";
34
35 }}
36
37 ?>
38 <!--end of fetch process-->
39
40 <!DOCTYPE html>
41 <html>
42
43 <head>
44 <meta charset="utf-8">
45 <meta name="viewport" content="width=device-width, initial-scale=1.0">
46 <title>school management system</title>
47 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
48 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
49 <link href="assets/css/loader.css" rel="stylesheet" />
50 <script src="assets/js/canvasjs.min.js"></script>
51 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
52 <script src="assets/js/jquery-3.2.1.js"></script>
53 </head>
54
55 <body >
56 <!--end of heading section-->
57 <ul class="nav navbar-right top-nav">
58 <div class="dropdown">
59 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
60 <?php
61 //Check to see if the user is logged in.if not redirect user to the loging page.
62
63 if(isset($_SESSION['fname']))
64 {
65 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
66 }else{
67 echo "<script type='text/javascript'>
68 alert( 'You must Log in to use the system');
69 </script>";
70 echo "<script>
71 window.location = 'index.php'
72 </script>";
73 }
74 ?>
75 <span class="caret"></span></button>
76 <ul class="dropdown-menu">
77 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
78 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
79 <li class="divider"></li>
80 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
81 </ul>
82 </div>
83 </ul>
84 <!--************************************************-->
85 <div style="
86 font-family:Nyala, Arial;
87 text-align: left;
88 background-color: #526F35;
89 padding: 20px;
90 color:white;
91 width: 100%;
92 height: 150px;">
93 <!--This codes to load the image loader-->
94 <div id="loading">
95 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
96 </div>
97 <!--this is the heading section-->
98 <h2>
99 <?php
100 $query=mysqli_query($conn,"select * from companyinfo");
101 $num_rows=mysqli_num_rows($query);
102 while($row=mysqli_fetch_array($query))
103 {
104 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
105 $cname = $row['cname'];
106 $cemail = $row['cemail'];
107 $ccontact = $row['ccontact'];
108 $clocation = $row['clocation'];
109 }?>
110 <?php
111 echo $cname;
112 ?>
113
114 <div style="float:right; font-size:20px;text-align:right;">
115
116 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
117 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
118 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
119
120 </div>
121 </h2>
122 </div>
123 <!--end of heading section-->
124
125 <div style="float:left;"></div></div><div style="float:right;"> Current User: <font color="orange">John</font> <a href="xxx">Log Out<img src="assets/img/logout.png"></a></div><hr>
126
127 <div>
128 <ul class="nav nav-tabs">
129 <li ><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
130 <li ><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
131 <li ><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
132 <li ><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
133 <li><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
134 <li><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
135 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
136 <li><a href="sms.php">SMS <img src="assets/img/details.png"></a></li>
137 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
138 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
139
140 </ul>
141 <div class="tab-content">
142 <div class="tab-pane active" role="tabpanel" id="tab-1">
143
144 <p>
145 <div class="table-responsive" >
146
147 <!--THIS IS WHERE YOU PUT YOUR CODES-->
148 <div class="row">
149 <div class="col-sm-3">
150 </div>
151
152 <div class="col-sm-6">
153 <div>
154 <form action="updatecompanyinfo.php" method="post" enctype="multipart/form-data">
155 <label>Company name</label>
156 <input type="text" name="cname" required class="form-control" value="<?php echo $cname ?>"/><br/>
157
158 <label>Email address</label>
159 <input type="text" name="cemail" required class="form-control" value="<?php echo $cemail ?>"/><br/>
160
161 <label>Contact</label>
162 <input type="text" name="ccontact" required class="form-control" value="<?php echo $ccontact ?>"/><br/>
163
164 <label>Location</label>
165 <input type="text" name="clocation" required class="form-control" value="<?php echo $clocation ?>"/><br/>
166
167 <label>Logo (82px x 82px)</label>
168 <input type="file" name="clogo" required class="form-control" /><br/>
169
170
171
172 <input type="submit" name="register" class="btn btn-primary" value="Update Details">
173 </form>
174 </div>
175 </div>
176
177 </div>
178
179 <div div class="col-md-12" style="background-color:#526F35;bottom:0px; position:fixed;">
180 <p class="text-center text-danger" style="color:white;">@J. Muthama Tel: +254729734768</p>
181 </div>
182 <script src="assets/js/jquery.min.js"></script>
183 <script src="assets/bootstrap/js/bootstrap.min.js"></script>
184 <script src="assets/js/affix.js"></script>
185 <script src="assets/js/alert.js"></script>
186 <script src="assets/js/alert1.js"></script>
187 <script src="assets/js/bootstrap.js"></script>
188 <script src="assets/js/bootstrap.min.js"></script>
189 <script src="assets/js/bootstrap-datepicker.js"></script>
190 <script src="assets/js/bootstrap-wysihtml5.js"></script>
191 <script src="assets/js/button.js"></script>
192 <script src="assets/js/carousel.js"></script>
193 <script src="assets/js/chosen.jquery.min.js"></script>
194 <script src="assets/js/ckeditor.js"></script>
195 <script src="assets/js/collapse.js"></script>
196 <script src="assets/js/color.js"></script>
197 <script src="assets/js/dropdown.js"></script>
198 <script src="assets/js/DT_bootstrap.js"></script>
199 <script src="assets/js/dynamic.js"></script>
200 <script src="assets/js/ie-emulation-modes-warning.js"></script>
201 <script src="assets/js/jquery.dataTables.js"></script>
202 <script src="assets/js/jquery.dataTables.min.js"></script>
203 <script src="assets/js/jquery.dialog.js"></script>
204 <script src="assets/js/jquery.hoverdir.js"></script>
205 <script src="assets/js/jquery.jgrowl.js"></script>
206 <script src="assets/js/jquery.knob.js"></script>
207 <script src="assets/js/jquery.uniform.min.js"></script>
208 <script src="assets/js/jquery-1.8.3.min.js"></script>
209 <script src="assets/js/jquery-1.9.1.js"></script>
210 <script src="assets/js/jquery-1.9.1.min.js"></script>
211 <script src="assets/js/jquery-1.10.2.js"></script>
212 <script src="assets/js/jquery-1.11.0.js"></script>
213 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
214 <script src="assets/js/jquery-ui-1.10.3.js"></script>
215 <script src="assets/js/modal.js"></script>
216 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
217 <script src="assets/js/myjquery.js"></script>
218 <script src="assets/js/myjquery1.js"></script>
219 <script src="assets/js/npm.js"></script>
220 <script src="assets/js/popover.js"></script>
221 <script src="assets/js/profile.js"></script>
222 <script src="assets/js/raphael-min.js"></script>
223 <script src="assets/js/sb-admin-2.js"></script>
224 <script src="assets/js/scripts.js"></script>
225 <script src="assets/js/scrollspy.js"></script>
226 <script src="assets/js/tab.js"></script>
227 <script src="assets/js/tooltip.js"></script>
228 <script src="assets/js/transition.js"></script>
229 <script src="assets/js/wysihtml5-0.3.0.js"></script>
230 <script src="assets/js/slideshow.js"></script>
231 <script language="javascript" type="text/javascript">
232 $(window).load(function()
233 {
234 $('#loading').hide();
235 });
236 </script>
237 </body>
238
239 </html>